← Return to doc.sitecore.com

  Installation Guide for DMS on Oracle
Print this page (opens in new window) Print

Prerequisites:

Follow the instructions below to install Sitecore DMS for Oracle:

  1. Download the zip-archive with DMS for Oracle from the CMS and DMS Downloads page.
  2. Extract the contents of the zip-archive to a folder on your disk.
  3. On the Database Server, perform the following steps:
    1. Load Sitecore data into the <database name> Oracle database.
    2. In your computer‘s System Properties/Advanced/Environment Variables set up variables as follows:
      DATABASE = <database name> The name of the Oracle Database instance that will host Sitecore data (as set up on the PC).
      TBS = Name of the tablespace for Sitecore data.
      PASSWORD = password for the system user of the Oracle instance.
      PREFIX = <prefix> Prefix to use for user schema names and passwords (default: sc).
    3. In the folder created after extracting Sitecore DMS (Oracle) distributive, launch createdata.bat.
    4. Remove PASSWORD, PREFIX, DATABASE and TBS variables from the environment.
  4. On each Web Server, perform the following steps:
    1. Add the following string in the ConnectionStringsOracle.config file:
      <add name="analytics" connectionString="user id=<prefix>analytics;password=<prefix>analytics;Data Source=<database name>"/>
    2. Copy the Sitecore.Analytics.config file and the Sitecore.Analytics.ExlcudeRobots.config file to the /App_Config/Include/ folder.
    3. In Sitecore 7.2 and later, also copy the Sitecore.Analytics.RobotDetection.config file to the /App_Config/Include/ folder.
    4. Update relevant web.config and Sitecore.Analytics.config settings, such as MailServer and Analytics.EMailFromAddress (for sending out reports as emails).
    5. If you wish to use DMS with Sitecore MVC, rename the /App_Config/Include/Sitecore.MvcAnalytics.config.disabled to Sitecore.MvcAnalytics.config.
    6. Modify existing layouts and put in a <sc:VisitorIdentification runat="server"/> Web control in the <head> block to enable automatic robot detection.
      To make this work, you should also add the appropriate namespace definition in each layout and sublayout. This can be done in web.config, for instance:
      <system.web>
        <!-- Continue to run Sitecore without script validations -->
        <pages validateRequest="false">
          <controls>
            <add tagPrefix="sc" namespace="Sitecore.Web.UI.WebControls" assembly="Sitecore.Analytics"/>
      See Engagement Analytics Configuration Reference for more details about relevant settings and the <sc:VisitorIdentification /> web control.
    7. Update the Analytics.PerformLookup setting in the /App_Config/Include/Sitecore.Analytics.config file to limit the lookup activity to one server.
      Note: You can enable lookups on either a CM or a CD instance. The Sitecore instance should be able to access the MaxMind web service.
      See MaxMind Signup and Purchase for more details about GeoIP lookup functionality.
    8. Restart Internet Information Services (IIS).

For more information about how to setup Oracle database server and web server separately, see Sitecore CMS Installation Guide.

Sitecore DMS for Oracle is now configured properly.